﻿Imports System.Data.SqlClient
Imports System.Data
Imports _0971023_0971029.DataProvider
Imports _0971023_0971029.NguoiChoThue_DTO

Public Class NhaMoiDang_DAO
    Public Shared Function LoadFromNhaMoiDang() As DataTable
        Dim cn As SqlConnection = DataProvider.KetNoi()

        Dim Comman As SqlCommand = New SqlCommand("HienNhaDang", cn)
        Comman.CommandType = CommandType.StoredProcedure

        Dim cm As SqlDataAdapter = New SqlDataAdapter(Comman)
        Dim bang As DataTable = New DataTable()

        cm.Fill(bang)

        cn.Close()
        Return bang
    End Function
End Class
